/*
 Navicat Premium Data Transfer

 Source Server         : 39.104.171.133
 Source Server Type    : MySQL
 Source Server Version : 50724
 Source Host           : 39.104.171.133:3306
 Source Schema         : fadmin

 Target Server Type    : MySQL
 Target Server Version : 50724
 File Encoding         : 65001

 Date: 20/11/2020 14:29:27
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for n_admin_gonggao
-- ----------------------------
DROP TABLE IF EXISTS `n_admin_gonggao`;
CREATE TABLE `n_admin_gonggao` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `content` varchar(255) DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of n_admin_gonggao
-- ----------------------------
BEGIN;
INSERT INTO `n_admin_gonggao` VALUES (7, '测试公告', '<p><img src=\"http://kunakun.6655.la/5ce60bb7-c08b-4804-a4e7-65f7c333f0e0.jpg\" data-filename=\"filename\" style=\"width: 481px;\"><br></p>', '2020-09-11 17:46:50', '2020-09-11 17:46:50');
COMMIT;

-- ----------------------------
-- Table structure for n_admin_quartz
-- ----------------------------
DROP TABLE IF EXISTS `n_admin_quartz`;
CREATE TABLE `n_admin_quartz` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '用于子任务唯一标识',
  `job_name` varchar(255) DEFAULT NULL COMMENT '定时器名称',
  `bean_name` varchar(255) DEFAULT NULL COMMENT 'Bean名称',
  `method_name` varchar(255) DEFAULT NULL COMMENT '方法名称',
  `params` varchar(255) DEFAULT NULL COMMENT '参数',
  `cron_expression` varchar(255) DEFAULT NULL COMMENT 'cron表达式',
  `is_pause` tinyint(255) DEFAULT NULL COMMENT '状态，暂时或启动',
  `email` varchar(255) DEFAULT NULL COMMENT '报警邮箱',
  `description` varchar(255) DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of n_admin_quartz
-- ----------------------------
BEGIN;
INSERT INTO `n_admin_quartz` VALUES (1, '新浪爬虫', 'testTask', 'run1', '我是参数', '*/2 * * * * ?', 1, '1321366271@qq.com', '新浪爬虫每1小时运行一次', '2020-09-11 16:22:26', '2020-09-11 22:45:56');
INSERT INTO `n_admin_quartz` VALUES (2, '搜狐爬虫', 'testTask', 'run', '', '*/2 * * * * ?', 1, '1321366271@qq.com', '搜狐爬虫每1小时运行一次', '2020-09-11 17:27:51', '2020-09-11 23:21:31');
COMMIT;

-- ----------------------------
-- Table structure for n_admin_resource
-- ----------------------------
DROP TABLE IF EXISTS `n_admin_resource`;
CREATE TABLE `n_admin_resource` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) DEFAULT NULL COMMENT '标题',
  `icon` varchar(100) DEFAULT NULL COMMENT '图标',
  `url` varchar(100) DEFAULT NULL COMMENT '访问路径',
  `onemenu` int(11) DEFAULT NULL COMMENT '一级菜单1一级0二级',
  `pid` int(11) DEFAULT NULL COMMENT '上级id',
  `weight` int(11) DEFAULT NULL COMMENT '权重',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` int(11) DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `url` (`url`) USING BTREE,
  KEY `title` (`title`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=231 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='后台菜单资源表';

-- ----------------------------
-- Records of n_admin_resource
-- ----------------------------
BEGIN;
INSERT INTO `n_admin_resource` VALUES (1, '控制台', 'fa fa-dashboard', '/sys/dashboard/index', 0, 4, 1, '2020-01-07 13:25:38', '2020-01-09 16:51:40', 1);
INSERT INTO `n_admin_resource` VALUES (2, '用户管理', 'fa fa-address-card', '/sys/user/index', 0, 4, 2, '2020-01-07 16:30:30', '2020-08-23 17:19:35', 1);
INSERT INTO `n_admin_resource` VALUES (3, '规则管理', 'fa fa-file-word-o', '/sys/menu/index', 0, 4, 300, '2020-01-07 17:43:27', '2020-08-23 17:19:58', 1);
INSERT INTO `n_admin_resource` VALUES (4, '系统选项', 'fa fa-address-book-o', '#', 1, 0, 400, '2020-01-08 23:01:29', '2020-07-25 18:46:22', 1);
INSERT INTO `n_admin_resource` VALUES (66, '用户管理-新增', 'fa fa-cogs', '/sys/user/add', 2, 2, 2, '2020-01-09 12:12:40', '2020-01-10 21:30:18', 1);
INSERT INTO `n_admin_resource` VALUES (67, '删除用户', 'fa fa-cogs', '/sys/user/del', 2, 2, 2, '2020-01-09 12:14:19', NULL, 1);
INSERT INTO `n_admin_resource` VALUES (69, '保存或修改用户', 'fa fa-bank', '/sys/user/save', 2, 2, 2, '2020-01-09 17:00:17', NULL, 1);
INSERT INTO `n_admin_resource` VALUES (70, '角色管理', 'fa fa-anchor', '/sys/role/index', 0, 4, 404, '2020-01-09 17:21:27', '2020-08-22 21:04:19', 1);
INSERT INTO `n_admin_resource` VALUES (71, '新增规则', 'fa fa-address-book', '/sys/menu/add', 2, 3, 3, '2020-01-10 20:35:35', NULL, 1);
INSERT INTO `n_admin_resource` VALUES (72, '规则保存', 'fa fa-cogs', '/sys/menu/save', 2, 3, 3, '2020-01-10 20:36:10', NULL, 1);
INSERT INTO `n_admin_resource` VALUES (73, '规则删除', 'fa fa-cogs', '/sys/menu/del', 2, 3, 3, '2020-01-10 20:36:30', NULL, 1);
INSERT INTO `n_admin_resource` VALUES (74, '用户列表访问', 'fa fa-archive', '/sys/user/data', 2, 2, 1, '2020-01-10 21:10:14', NULL, 1);
INSERT INTO `n_admin_resource` VALUES (75, '用户授权', 'fa fa-cogs', 'sys/user/grank', 2, 2, 1, '2020-01-10 21:10:55', '2020-01-10 21:11:00', 1);
INSERT INTO `n_admin_resource` VALUES (76, '用户授权-功能', 'fa fa-cogs', '/sys/user/granklist', 2, 2, 1, '2020-01-10 21:14:03', NULL, 1);
INSERT INTO `n_admin_resource` VALUES (77, '角色授权-操作', 'fa fa-cogs', '/sys/role/tree', 2, 70, 1, '2020-01-10 21:15:06', NULL, 1);
INSERT INTO `n_admin_resource` VALUES (78, '角色列表', 'fa fa-cogs', '/sys/role/data', 2, 70, 1, '2020-01-10 21:15:42', NULL, 1);
INSERT INTO `n_admin_resource` VALUES (79, '角色管理-编辑', 'fa fa-cogs', '/sys/role/edit', 2, 70, 1, '2020-01-10 21:16:39', NULL, 1);
INSERT INTO `n_admin_resource` VALUES (81, '角色管理-新增角色', 'fa fa-cogs', '/sys/role/add', 2, 70, 1, '2020-01-10 21:17:12', NULL, 1);
INSERT INTO `n_admin_resource` VALUES (82, '角色管理-保存', 'fa fa-cogs', '/sys/role/save', 2, 70, 1, '2020-01-10 21:17:40', NULL, 1);
INSERT INTO `n_admin_resource` VALUES (83, '角色管理-删除', 'fa fa-cogs', '/sys/role/del', 2, 70, 1, '2020-01-10 21:17:59', '2020-01-11 14:40:19', 1);
INSERT INTO `n_admin_resource` VALUES (85, '规则管理-数据', 'fa fa-cogs', '/sys/menu/data', 2, 3, 1, '2020-01-10 21:19:19', NULL, 1);
INSERT INTO `n_admin_resource` VALUES (87, '用户管理-编辑', 'fa fa-cogs', '/sys/user/edit', 2, 2, 1, '2020-01-10 21:26:26', NULL, 1);
INSERT INTO `n_admin_resource` VALUES (88, '用户管理-授权', 'fa fa-cogs', '/sys/user/grank', 2, 2, 1, '2020-01-10 21:27:37', '2020-01-10 21:32:15', 1);
INSERT INTO `n_admin_resource` VALUES (89, '规则管理-编辑', 'fa fa-cogs', '/sys/menu/edit', 2, 3, 1, '2020-01-10 21:29:26', '2020-01-10 21:29:49', 1);
INSERT INTO `n_admin_resource` VALUES (115, '公告列表', 'fa fa-cogs', '/sys/gonggao/index', 0, 199, 1, '2020-02-28 22:06:19', '2020-08-15 20:39:34', 1);
INSERT INTO `n_admin_resource` VALUES (116, '公告数据', 'fa fa-cogs', '/sys/gonggao/data', 2, 115, 1, '2020-02-28 22:07:13', NULL, 1);
INSERT INTO `n_admin_resource` VALUES (117, '公告添加', 'fa fa-cogs', '/sys/gonggao/add', 2, 115, 1, '2020-02-28 22:11:54', NULL, 1);
INSERT INTO `n_admin_resource` VALUES (118, '公告删除', 'fa fa-cogs', '/sys/gonggao/del', 2, 115, 1, '2020-02-28 22:12:12', NULL, 1);
INSERT INTO `n_admin_resource` VALUES (119, '公告保存', 'fa fa-cogs', '/sys/gonggao/save', 2, 115, 1, '2020-02-28 22:12:30', '2020-02-28 22:13:24', 1);
INSERT INTO `n_admin_resource` VALUES (120, '公告编辑', 'fa fa-cogs', '/sys/gonggao/edit', 2, 115, 1, '2020-02-28 22:12:50', NULL, 1);
INSERT INTO `n_admin_resource` VALUES (199, '其他选项', 'fa fa-arrow-circle-left', '#', 1, 0, 1, '2020-08-15 16:00:35', '2020-09-11 16:01:46', 1);
INSERT INTO `n_admin_resource` VALUES (224, '系统说明文档书', 'fa fa-cogs', '/swagger-ui.html', 0, 199, 1, '2020-09-11 16:02:32', '2020-09-11 16:03:17', 1);
INSERT INTO `n_admin_resource` VALUES (225, '定时任务', 'fa fa-cogs', '/sys/quartzjob/index', 0, 199, 1, '2020-09-11 16:13:42', NULL, 1);
INSERT INTO `n_admin_resource` VALUES (226, '删除', 'fa fa-cogs', '/sys/quartzjob/del', 2, 225, 1, '2020-09-11 16:17:50', NULL, 1);
INSERT INTO `n_admin_resource` VALUES (227, '数据', 'fa fa-cogs', '/sys/quartzjob/data', 2, 225, 1, '2020-09-11 16:18:03', NULL, 1);
INSERT INTO `n_admin_resource` VALUES (228, '添加', 'fa fa-cogs', '/sys/quartzjob/add', 2, 225, 1, '2020-09-11 16:18:12', NULL, 1);
INSERT INTO `n_admin_resource` VALUES (229, '编辑', 'fa fa-cogs', '/sys/quartzjob/edit', 2, 225, 1, '2020-09-11 16:18:23', '2020-09-11 16:18:47', 1);
INSERT INTO `n_admin_resource` VALUES (230, '保存', 'fa fa-cogs', '/sys/quartzjob/save', 2, 225, 1, '2020-09-11 16:18:29', NULL, 1);
COMMIT;

-- ----------------------------
-- Table structure for n_admin_role
-- ----------------------------
DROP TABLE IF EXISTS `n_admin_role`;
CREATE TABLE `n_admin_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_key` varchar(50) NOT NULL,
  `role_desc` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of n_admin_role
-- ----------------------------
BEGIN;
INSERT INTO `n_admin_role` VALUES (1, 'ROLE_ADMIN', '超级管理员');
INSERT INTO `n_admin_role` VALUES (2, 'ROLE_MEMBER', '普通用户');
INSERT INTO `n_admin_role` VALUES (3, 'ROLE_SUPER', '普通');
INSERT INTO `n_admin_role` VALUES (4, 'ROLE_ROLE1', '经理');
COMMIT;

-- ----------------------------
-- Table structure for n_admin_role_resource
-- ----------------------------
DROP TABLE IF EXISTS `n_admin_role_resource`;
CREATE TABLE `n_admin_role_resource` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `role_id` int(11) NOT NULL,
  `resource_id` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5347 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of n_admin_role_resource
-- ----------------------------
BEGIN;
INSERT INTO `n_admin_role_resource` VALUES (5309, 1, 1);
INSERT INTO `n_admin_role_resource` VALUES (5310, 1, 66);
INSERT INTO `n_admin_role_resource` VALUES (5311, 1, 67);
INSERT INTO `n_admin_role_resource` VALUES (5312, 1, 69);
INSERT INTO `n_admin_role_resource` VALUES (5313, 1, 74);
INSERT INTO `n_admin_role_resource` VALUES (5314, 1, 75);
INSERT INTO `n_admin_role_resource` VALUES (5315, 1, 76);
INSERT INTO `n_admin_role_resource` VALUES (5316, 1, 87);
INSERT INTO `n_admin_role_resource` VALUES (5317, 1, 88);
INSERT INTO `n_admin_role_resource` VALUES (5318, 1, 2);
INSERT INTO `n_admin_role_resource` VALUES (5319, 1, 71);
INSERT INTO `n_admin_role_resource` VALUES (5320, 1, 72);
INSERT INTO `n_admin_role_resource` VALUES (5321, 1, 73);
INSERT INTO `n_admin_role_resource` VALUES (5322, 1, 85);
INSERT INTO `n_admin_role_resource` VALUES (5323, 1, 89);
INSERT INTO `n_admin_role_resource` VALUES (5324, 1, 3);
INSERT INTO `n_admin_role_resource` VALUES (5325, 1, 77);
INSERT INTO `n_admin_role_resource` VALUES (5326, 1, 78);
INSERT INTO `n_admin_role_resource` VALUES (5327, 1, 79);
INSERT INTO `n_admin_role_resource` VALUES (5328, 1, 81);
INSERT INTO `n_admin_role_resource` VALUES (5329, 1, 82);
INSERT INTO `n_admin_role_resource` VALUES (5330, 1, 83);
INSERT INTO `n_admin_role_resource` VALUES (5331, 1, 70);
INSERT INTO `n_admin_role_resource` VALUES (5332, 1, 4);
INSERT INTO `n_admin_role_resource` VALUES (5333, 1, 116);
INSERT INTO `n_admin_role_resource` VALUES (5334, 1, 117);
INSERT INTO `n_admin_role_resource` VALUES (5335, 1, 118);
INSERT INTO `n_admin_role_resource` VALUES (5336, 1, 119);
INSERT INTO `n_admin_role_resource` VALUES (5337, 1, 120);
INSERT INTO `n_admin_role_resource` VALUES (5338, 1, 115);
INSERT INTO `n_admin_role_resource` VALUES (5339, 1, 224);
INSERT INTO `n_admin_role_resource` VALUES (5340, 1, 226);
INSERT INTO `n_admin_role_resource` VALUES (5341, 1, 227);
INSERT INTO `n_admin_role_resource` VALUES (5342, 1, 228);
INSERT INTO `n_admin_role_resource` VALUES (5343, 1, 229);
INSERT INTO `n_admin_role_resource` VALUES (5344, 1, 225);
INSERT INTO `n_admin_role_resource` VALUES (5345, 1, 199);
INSERT INTO `n_admin_role_resource` VALUES (5346, 1, 230);
COMMIT;

-- ----------------------------
-- Table structure for n_admin_user
-- ----------------------------
DROP TABLE IF EXISTS `n_admin_user`;
CREATE TABLE `n_admin_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) DEFAULT NULL COMMENT '用户名',
  `password` varchar(255) DEFAULT NULL COMMENT '密码',
  `email` varchar(255) DEFAULT NULL COMMENT '电子邮箱',
  `phone` varchar(255) DEFAULT NULL COMMENT '手机号',
  `sex` tinyint(4) DEFAULT NULL,
  `avatar` varchar(2550) DEFAULT NULL COMMENT '头像',
  `open_id` varchar(255) DEFAULT NULL,
  `status` tinyint(4) DEFAULT '0' COMMENT '状态：1被冻结 0正常',
  `reset_password_time` timestamp NULL DEFAULT NULL COMMENT '最新修改密码的时间',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `city` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `province` varchar(255) DEFAULT NULL,
  `nickname` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `open_id_index` (`open_id`) USING BTREE COMMENT ' open_id的数据库索引'
) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户表';

-- ----------------------------
-- Records of n_admin_user
-- ----------------------------
BEGIN;
INSERT INTO `n_admin_user` VALUES (108, 'admin', '123456', '1321366271@qq.com', '17839696895', NULL, 'http://kunakun.6655.la/11d9f5d2-add1-400b-b3c7-ddbd2919212c.jpg', NULL, 1, NULL, '2020-01-11 15:54:34', '2020-09-11 23:37:11', NULL, NULL, NULL, '杨坤');
COMMIT;

-- ----------------------------
-- Table structure for n_admin_user_role
-- ----------------------------
DROP TABLE IF EXISTS `n_admin_user_role`;
CREATE TABLE `n_admin_user_role` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of n_admin_user_role
-- ----------------------------
BEGIN;
INSERT INTO `n_admin_user_role` VALUES (25, 108, 1);
COMMIT;

-- ----------------------------
-- Table structure for n_admin_worktime
-- ----------------------------
DROP TABLE IF EXISTS `n_admin_worktime`;
CREATE TABLE `n_admin_worktime` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `start_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `end_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of n_admin_worktime
-- ----------------------------
BEGIN;
INSERT INTO `n_admin_worktime` VALUES (1, 108, '2020-01-01 22:20:12', '2020-01-18 22:20:13');
INSERT INTO `n_admin_worktime` VALUES (2, 95, '2020-01-31 21:14:50', '2020-01-30 21:14:52');
INSERT INTO `n_admin_worktime` VALUES (17, 95, '2020-01-31 21:14:50', '2020-01-30 21:14:52');
INSERT INTO `n_admin_worktime` VALUES (18, 108, '2020-01-01 22:20:12', '2020-01-18 22:20:13');
INSERT INTO `n_admin_worktime` VALUES (19, 108, '2020-01-31 21:14:50', '2020-01-30 21:14:52');
INSERT INTO `n_admin_worktime` VALUES (20, 95, '2020-01-31 21:14:50', '2020-01-30 21:14:52');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
